home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
sound.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
799b
|
21 lines
/* RCSVER $Id: sound.sql,v 1.4 2000-02-03 11:53:38-06 randy Exp $ */
/* *************************************************************************
* Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
*
* Name: sound.sql
* Date: 02/17/1999
* memo: Randy Wood
* Description: Create the sound table. This table contains a mapping
* of sound classes to actual sounds at the farebox.
* Changes:
************************************************************************* */
CREATE TABLE sound
(
sound_class NUMBER(38), /* Sound class */
actual_sound NUMBER(38), /* Actual sound assigned to sound class */
config_num NUMBER(38)
CONSTRAINT ref1_sound REFERENCES configset(num)
ON DELETE CASCADE,
CONSTRAINT pk_sound PRIMARY KEY (sound_class, config_num)
);